BikeVibe
Bike’s Sales Analysis

This project aims to provide valuable insights to develop marketing stratergies and improve sales.

Introduction

In this project, I analyzed sales data to understand the bike purchasing patterns across different demographics such as gender, marital status, distance traveled, region, and education level.

Goal

Help BikeBive create targeted marketing strategies and optimize sales efforts by investigating the different factors that influence on the purchase of bicycles.

Results

The results of the project are presented through an interactive Excel dashboard. Also, a brief report at the end of this page summarizes the most important results and suggestions.

Tools used:

  • Data collection: GitHub.
  • Data exploration, analysis, and visualization: Excel.

Case - What are the main factors that influence the decision to buy a bicycle at BikeVibe and how can they be used to optimize marketing and sales strategies?

I conducted an analysis using pivot tables and visualizations to identify the key factors such as income, gender, marital status, distance, region, and education level. The insights suggest a complex interplay of these factors, influencing the customers' decisions to purchase bikes. Stakeholders can refer to all the data and an interactive Excel dashboard for more details.

Visualization:

Click here to interact with the Excel Dashboard.

Key Findings, Conclusions, and Recommendations:

  • Married individuals generally have a higher income and are more likely to buy bikes. Special promotions or targeted marketing to families could be beneficial.
  • Women have a slightly lower average income compared to men but show similar purchasing patterns.
  • Customers traveling shorter distances (0-1 Miles) show the highest purchase count. To optimize sales, consider developing products that cater to the needs of individuals traveling shorter distances.
  • North America shows higher income and more bike purchases compared to Europe and Pacific regions. Therefore, consider focusing marketing campaigns on North America.
  • Customers with Graduate Degrees and bachelors have higher incomes and are more inclined to buy bikes. It is recommended to design marketing campaigns specifically targeting higher-income segments like Graduated Degree and Bachelors.

    • References and Links: